30. Quiz: Show Me

Assure you are on a new sheet.

Simultaneously select Market, Category, and Profit. Notice the plots available.

Select the side by side bar charts.

Quiz 1 below.

Create a new sheet or clear your current sheet.

Simultaneously select Country and Profit.

Select the Map from Show Me that looks shaded (not the one with the circles).

Drag Country to the Filters table.

Select Show Filter from the drop down menu associated with Country in the Filters table.

Change the Filter to Multiple Values (dropdown)

Select different countries to see the updates. Cool right!

Add a similar filter for Sub-Category.

Quiz 2 below.